Dataset info
| Number of variables | 37 |
|---|---|
| Number of observations | 6673 |
| Missing cells | 10945 (< 0.1%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 1.7 MiB |
| Average record size in memory | 261.0 B |
Variables types
| Numeric | 15 |
|---|---|
| Categorical | 4 |
| Boolean | 4 |
| Date | 0 |
| URL | 1 |
| Text (Unique) | 0 |
| Rejected | 13 |
| Unsupported | 0 |
Warnings
accuracy has 2210 (33.1%) zeros | Zeros |
avg_rating is highly correlated with accuracy (ρ = 0.99232) | Rejected |
bedrooms has 446 (6.7%) zeros | Zeros |
checkin is highly correlated with avg_rating (ρ = 0.98906) | Rejected |
cleanliness is highly correlated with checkin (ρ = 0.98857) | Rejected |
communication is highly correlated with cleanliness (ρ = 0.98852) | Rejected |
currency has constant value "CAD" | Rejected |
guest_satisfication is highly correlated with communication (ρ = 0.99219) | Rejected |
host_reviews has 841 (12.6%) zeros | Zeros |
is_business_travel_ready has constant value "False" | Rejected |
listing_name has a high cardinality: 6587 distinct values | Warning |
localized_city has a high cardinality: 96 distinct values | Warning |
localized_neighborhood has constant value "nan" | Rejected |
location is highly correlated with guest_satisfication (ρ = 0.98793) | Rejected |
price is highly correlated with amt_w_service (ρ = 1) | Rejected |
rate_type has constant value "nightly" | Rejected |
response_rate has 1328 (19.9%) zeros | Zeros |
response_time has 1217 (18.2%) missing values | Missing |
reviews_count has 2089 (31.3%) zeros | Zeros |
star_rating is highly correlated with guest_satisfication (ρ = 0.91733) | Rejected |
value is highly correlated with location (ρ = 0.98687) | Rejected |
accuracy
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.4135 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 33.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 9 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 4.5712 |
|---|---|
| Coef of variation | 0.71275 |
| Kurtosis | -1.5172 |
| Mean | 6.4135 |
| MAD | 4.2838 |
| Skewness | -0.65808 |
| Sum | 42797 |
| Variance | 20.896 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 10 | 3202 | 48.0% | |
| 0 | 2210 | 33.1% | |
| 9 | 972 | 14.6% | |
| 8 | 169 | < 0.1% | |
| 7 | 45 | < 0.1% | |
| 6 | 45 | < 0.1% | |
| 2 | 15 | < 0.1% | |
| 4 | 11 | < 0.1% | |
| 5 | 3 | < 0.1% | |
| 3 | 1 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2210 | 33.1% | |
| 2 | 15 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 11 | < 0.1% | |
| 5 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 3202 | 48.0% | |
| 9 | 972 | 14.6% | |
| 8 | 169 | < 0.1% | |
| 7 | 45 | < 0.1% | |
| 6 | 45 | < 0.1% |
amt_w_service
Numeric
| Distinct count | 525 |
|---|---|
| Unique (%) | 7.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 194.01 |
|---|---|
| Minimum | 14 |
| Maximum | 994 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 14 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 66 |
| Median | 119 |
| Q3 | 248 |
| 95-th percentile | 655 |
| Maximum | 994 |
| Range | 980 |
| Interquartile range | 182 |
Descriptive statistics
| Standard deviation | 194.87 |
|---|---|
| Coef of variation | 1.0044 |
| Kurtosis | 2.9665 |
| Mean | 194.01 |
| MAD | 144.79 |
| Skewness | 1.8085 |
| Sum | 1.2946e+06 |
| Variance | 37973 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 132 | 131 | < 0.1% | |
| 105 | 112 | < 0.1% | |
| 99 | 108 | < 0.1% | |
| 72 | 91 | < 0.1% | |
| 86 | 87 | < 0.1% | |
| 171 | 87 | < 0.1% | |
| 103 | 86 | < 0.1% | |
| 69 | 86 | < 0.1% | |
| 112 | 83 | < 0.1% | |
| 82 | 82 | < 0.1% | |
| Other values (515) | 5720 | 85.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 14 | 34 | < 0.1% | |
| 16 | 28 | < 0.1% | |
| 17 | 44 | < 0.1% | |
| 18 | 16 | < 0.1% | |
| 20 | 43 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 994 | 1 | < 0.1% | |
| 986 | 13 | < 0.1% | |
| 985 | 4 | < 0.1% | |
| 980 | 1 | < 0.1% | |
| 972 | 1 | < 0.1% |
avg_rating
Highly correlated
This variable is highly correlated with accuracy and should be ignored for analysis
| Correlation | 0.99232 |
|---|
bathrooms
Numeric
| Distinct count | 26 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 2 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.8778 |
|---|---|
| Minimum | 0 |
| Maximum | 50 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1.5 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.371 |
|---|---|
| Coef of variation | 0.73014 |
| Kurtosis | 245.34 |
| Mean | 1.8778 |
| MAD | 0.88603 |
| Skewness | 8.8432 |
| Sum | 12526 |
| Variance | 1.8797 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 3247 | 48.7% | |
| 2 | 1563 | 23.4% | |
| 3 | 473 | 7.1% | |
| 2.5 | 408 | 6.1% | |
| 3.5 | 250 | < 0.1% | |
| 1.5 | 228 | < 0.1% | |
| 4 | 198 | < 0.1% | |
| 4.5 | 119 | < 0.1% | |
| 5 | 48 | < 0.1% | |
| 5.5 | 40 | < 0.1% | |
| Other values (15) | 97 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 8 | < 0.1% | |
| 0.5 | 3 | < 0.1% | |
| 1 | 3247 | 48.7% | |
| 1.5 | 228 | < 0.1% | |
| 2 | 1563 | 23.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 50 | 1 | < 0.1% | |
| 25 | 1 | < 0.1% | |
| 15 | 2 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 11 | 1 | < 0.1% |
bedrooms
Numeric
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 2 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.893 |
|---|---|
| Minimum | 0 |
| Maximum | 50 |
| Zeros (%) | 6.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 1.452 |
|---|---|
| Coef of variation | 0.76703 |
| Kurtosis | 194.63 |
| Mean | 1.893 |
| MAD | 0.96471 |
| Skewness | 7.3582 |
| Sum | 12628 |
| Variance | 2.1082 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 2658 | 39.8% | |
| 2 | 1865 | 27.9% | |
| 3 | 1061 | 15.9% | |
| 0 | 446 | 6.7% | |
| 4 | 436 | 6.5% | |
| 5 | 111 | < 0.1% | |
| 6 | 44 | < 0.1% | |
| 7 | 16 | < 0.1% | |
| 8 | 14 | < 0.1% | |
| 10 | 12 | < 0.1% | |
| Other values (7) | 8 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 446 | 6.7% | |
| 1 | 2658 | 39.8% | |
| 2 | 1865 | 27.9% | |
| 3 | 1061 | 15.9% | |
| 4 | 436 | 6.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 50 | 1 | < 0.1% | |
| 25 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
can_instant_book
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 4851 | 72.7% | |
| False | 1822 | 27.3% |
checkin
Highly correlated
This variable is highly correlated with avg_rating and should be ignored for analysis
| Correlation | 0.98906 |
|---|
cleanliness
Highly correlated
This variable is highly correlated with checkin and should be ignored for analysis
| Correlation | 0.98857 |
|---|
communication
Highly correlated
This variable is highly correlated with cleanliness and should be ignored for analysis
| Correlation | 0.98852 |
|---|
currency
Constant
This variable is constant and should be ignored for analysis
| Constant value | CAD |
|---|
guest_satisfication
Highly correlated
This variable is highly correlated with communication and should be ignored for analysis
| Correlation | 0.99219 |
|---|
host_id
Numeric
| Distinct count | 3442 |
|---|---|
| Unique (%) | 51.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.0767e+08 |
|---|---|
| Minimum | 40057 |
| Maximum | 2.7169e+08 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 40057 |
|---|---|
| 5-th percentile | 2.3517e+06 |
| Q1 | 3.5724e+07 |
| Median | 9.69e+07 |
| Q3 | 1.7227e+08 |
| 95-th percentile | 2.4591e+08 |
| Maximum | 2.7169e+08 |
| Range | 2.7165e+08 |
| Interquartile range | 1.3654e+08 |
Descriptive statistics
| Standard deviation | 7.969e+07 |
|---|---|
| Coef of variation | 0.74011 |
| Kurtosis | -1.1021 |
| Mean | 1.0767e+08 |
| MAD | 6.9024e+07 |
| Skewness | 0.36646 |
| Sum | 7.185e+11 |
| Variance | 6.3506e+15 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 1.4816e+07 | 57 | < 0.1% | |
| 5.8893e+07 | 52 | < 0.1% | |
| 1.1755e+08 | 33 | < 0.1% | |
| 2.7622e+07 | 32 | < 0.1% | |
| 9.702e+06 | 31 | < 0.1% | |
| 6.4321e+07 | 31 | < 0.1% | |
| 2.3783e+05 | 30 | < 0.1% | |
| 1.9585e+08 | 28 | < 0.1% | |
| 2.5315e+08 | 28 | < 0.1% | |
| 2.372e+07 | 28 | < 0.1% | |
| Other values (3432) | 6323 | 94.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 40057 | 2 | < 0.1% | |
| 65989 | 1 | < 0.1% | |
| 85132 | 1 | < 0.1% | |
| 1.0343e+05 | 2 | < 0.1% | |
| 1.1964e+05 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2.7169e+08 | 1 | < 0.1% | |
| 2.7163e+08 | 1 | < 0.1% | |
| 2.7159e+08 | 1 | < 0.1% | |
| 2.7131e+08 | 1 | < 0.1% | |
| 2.713e+08 | 1 | < 0.1% |
host_reviews
Numeric
| Distinct count | 418 |
|---|---|
| Unique (%) | 6.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 185.55 |
|---|---|
| Minimum | 0 |
| Maximum | 3334 |
| Zeros (%) | 12.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| Median | 33 |
| Q3 | 145 |
| 95-th percentile | 760 |
| Maximum | 3334 |
| Range | 3334 |
| Interquartile range | 141 |
Descriptive statistics
| Standard deviation | 466.25 |
|---|---|
| Coef of variation | 2.5128 |
| Kurtosis | 24.922 |
| Mean | 185.55 |
| MAD | 233.78 |
| Skewness | 4.737 |
| Sum | 1.2382e+06 |
| Variance | 2.1739e+05 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 841 | 12.6% | |
| 1 | 331 | < 0.1% | |
| 2 | 195 | < 0.1% | |
| 3 | 192 | < 0.1% | |
| 4 | 144 | < 0.1% | |
| 6 | 129 | < 0.1% | |
| 7 | 120 | < 0.1% | |
| 5 | 116 | < 0.1% | |
| 9 | 88 | < 0.1% | |
| 8 | 82 | < 0.1% | |
| Other values (408) | 4435 | 66.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 841 | 12.6% | |
| 1 | 331 | < 0.1% | |
| 2 | 195 | < 0.1% | |
| 3 | 192 | < 0.1% | |
| 4 | 144 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3334 | 57 | < 0.1% | |
| 3228 | 10 | < 0.1% | |
| 2818 | 4 | < 0.1% | |
| 2817 | 2 | < 0.1% | |
| 2551 | 21 | < 0.1% |
is_business_travel_ready
Constant
This variable is constant and should be ignored for analysis
| Constant value | False |
|---|
is_fully_refundable
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) | |
| True | 5164 | 77.4% | |
| False | 1509 | 22.6% |
is_new_listing
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 658 |
| Value | Count | Frequency (%) | |
| False | 6015 | 90.1% | |
| True | 658 | 9.9% |
is_superhost
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 4973 | 74.5% | |
| True | 1700 | 25.5% |
lat
Numeric
| Distinct count | 5712 |
|---|---|
| Unique (%) | 85.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 21.068 |
|---|---|
| Minimum | 20.45 |
| Maximum | 21.534 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20.45 |
|---|---|
| 5-th percentile | 20.628 |
| Q1 | 21.052 |
| Median | 21.134 |
| Q3 | 21.16 |
| 95-th percentile | 21.236 |
| Maximum | 21.534 |
| Range | 1.0834 |
| Interquartile range | 0.10737 |
Descriptive statistics
| Standard deviation | 0.17567 |
|---|---|
| Coef of variation | 0.0083382 |
| Kurtosis | 1.6448 |
| Mean | 21.068 |
| MAD | 0.12917 |
| Skewness | -1.5997 |
| Sum | 1.4058e+05 |
| Variance | 0.030859 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 21.26 | 21 | < 0.1% | |
| 21.158 | 17 | < 0.1% | |
| 21.12 | 11 | < 0.1% | |
| 21.14 | 9 | < 0.1% | |
| 21.185 | 8 | < 0.1% | |
| 21.152 | 8 | < 0.1% | |
| 21.16 | 7 | < 0.1% | |
| 21.051 | 6 | < 0.1% | |
| 21.131 | 5 | < 0.1% | |
| 21.152 | 5 | < 0.1% | |
| Other values (5702) | 6576 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20.45 | 1 | < 0.1% | |
| 20.453 | 1 | < 0.1% | |
| 20.454 | 1 | < 0.1% | |
| 20.456 | 1 | < 0.1% | |
| 20.458 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 21.534 | 1 | < 0.1% | |
| 21.529 | 1 | < 0.1% | |
| 21.528 | 1 | < 0.1% | |
| 21.525 | 1 | < 0.1% | |
| 21.524 | 1 | < 0.1% |
listing_name
Categorical
| Distinct count | 6587 |
|---|---|
| Unique (%) | > 99.9% |
| Missing (%) | < 0.1% |
| Missing (n) | 7 |
| New studio in Cancun downtown | 6 |
|---|---|
| Beautiful OCEANVIEW studio next to Forum! | 6 |
| ¡Studio Apartment 700 yards from the Beach! | 6 |
| Other values (6583) | |
| (Missing) | 7 |
| Value | Count | Frequency (%) | |
| New studio in Cancun downtown | 6 | < 0.1% | |
| Beautiful OCEANVIEW studio next to Forum! | 6 | < 0.1% | |
| ¡Studio Apartment 700 yards from the Beach! | 6 | < 0.1% | |
| Penthouse frente al mar | 3 | < 0.1% | |
| Departamento en Cancún | 3 | < 0.1% | |
| Club GR Solaris | 3 | < 0.1% | |
| Comfortable apartment on 2º floor | 3 | < 0.1% | |
| GR Caribe by Solaris | 3 | < 0.1% | |
| Club Solaris GR Caribe | 3 | < 0.1% | |
| Beautiful oceanfront condo | 3 | < 0.1% | |
| Other values (6576) | 6627 | > 99.9% | |
| (Missing) | 7 | < 0.1% |
| Max length | 118 |
|---|---|
| Mean length | 37.017 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
lng
Numeric
| Distinct count | 5497 |
|---|---|
| Unique (%) | 82.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -86.839 |
|---|---|
| Minimum | -87.392 |
| Maximum | -86.713 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -87.392 |
|---|---|
| 5-th percentile | -87.069 |
| Q1 | -86.864 |
| Median | -86.826 |
| Q3 | -86.781 |
| 95-th percentile | -86.739 |
| Maximum | -86.713 |
| Range | 0.67875 |
| Interquartile range | 0.08261 |
Descriptive statistics
| Standard deviation | 0.089203 |
|---|---|
| Coef of variation | -0.0010272 |
| Kurtosis | 3.458 |
| Mean | -86.839 |
| MAD | 0.062083 |
| Skewness | -1.6424 |
| Sum | -5.7948e+05 |
| Variance | 0.0079572 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| -86.75 | 21 | < 0.1% | |
| -86.833 | 17 | < 0.1% | |
| -86.846 | 11 | < 0.1% | |
| -86.86 | 9 | < 0.1% | |
| -86.824 | 8 | < 0.1% | |
| -86.807 | 8 | < 0.1% | |
| -86.823 | 6 | < 0.1% | |
| -86.826 | 6 | < 0.1% | |
| -86.783 | 5 | < 0.1% | |
| -86.749 | 5 | < 0.1% | |
| Other values (5487) | 6577 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -87.392 | 1 | < 0.1% | |
| -87.392 | 1 | < 0.1% | |
| -87.389 | 1 | < 0.1% | |
| -87.389 | 1 | < 0.1% | |
| -87.383 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| -86.713 | 1 | < 0.1% | |
| -86.715 | 1 | < 0.1% | |
| -86.715 | 1 | < 0.1% | |
| -86.715 | 1 | < 0.1% | |
| -86.715 | 1 | < 0.1% |
localized_city
Categorical
| Distinct count | 96 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Cancún | |
|---|---|
| Playa del Carmen | 584 |
| Isla Mujeres | 531 |
| Other values (93) |
| Value | Count | Frequency (%) | |
| Cancún | 4494 | 67.3% | |
| Playa del Carmen | 584 | 8.8% | |
| Isla Mujeres | 531 | 8.0% | |
| Puerto Morelos | 401 | 6.0% | |
| Alfredo V. Bonfil | 90 | < 0.1% | |
| Cancun | 72 | < 0.1% | |
| Quintana Roo | 68 | < 0.1% | |
| Riviera Maya | 55 | < 0.1% | |
| Cancún | 43 | < 0.1% | |
| Cancun | 30 | < 0.1% | |
| Other values (86) | 305 | < 0.1% |
| Max length | 44 |
|---|---|
| Mean length | 8.4721 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
localized_neighborhood
Constant
This variable is constant and should be ignored for analysis
| Constant value | nan |
|---|
location
Highly correlated
This variable is highly correlated with guest_satisfication and should be ignored for analysis
| Correlation | 0.98793 |
|---|
monthly_price_factor
Numeric
| Distinct count | 65 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.89186 |
|---|---|
| Minimum | 0.3 |
| Maximum | 1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.3 |
|---|---|
| 5-th percentile | 0.6 |
| Q1 | 0.8 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 0.7 |
| Interquartile range | 0.2 |
Descriptive statistics
| Standard deviation | 0.13793 |
|---|---|
| Coef of variation | 0.15466 |
| Kurtosis | 0.80455 |
| Mean | 0.89186 |
| MAD | 0.11417 |
| Skewness | -1.2075 |
| Sum | 5951.4 |
| Variance | 0.019025 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 3380 | 50.7% | |
| 0.8 | 626 | 9.4% | |
| 0.9 | 554 | 8.3% | |
| 0.85 | 507 | 7.6% | |
| 0.7 | 316 | < 0.1% | |
| 0.75 | 277 | < 0.1% | |
| 0.95 | 125 | < 0.1% | |
| 0.6 | 120 | < 0.1% | |
| 0.65 | 105 | < 0.1% | |
| 0.51 | 78 | < 0.1% | |
| Other values (55) | 585 | 8.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.3 | 4 | < 0.1% | |
| 0.33 | 1 | < 0.1% | |
| 0.34 | 1 | < 0.1% | |
| 0.35 | 3 | < 0.1% | |
| 0.37 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 3380 | 50.7% | |
| 0.99 | 4 | < 0.1% | |
| 0.98 | 4 | < 0.1% | |
| 0.97 | 7 | < 0.1% | |
| 0.96 | 2 | < 0.1% |
num_beds
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.7775 |
|---|---|
| Minimum | 0 |
| Maximum | 9 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 1.7192 |
|---|---|
| Coef of variation | 0.61899 |
| Kurtosis | 0.92203 |
| Mean | 2.7775 |
| MAD | 1.3727 |
| Skewness | 1.0802 |
| Sum | 18534 |
| Variance | 2.9557 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 1771 | 26.5% | |
| 2 | 1760 | 26.4% | |
| 3 | 1217 | 18.2% | |
| 4 | 864 | 12.9% | |
| 5 | 510 | 7.6% | |
| 6 | 279 | < 0.1% | |
| 7 | 120 | < 0.1% | |
| 8 | 89 | < 0.1% | |
| 9 | 40 | < 0.1% | |
| 0 | 23 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 23 | < 0.1% | |
| 1 | 1771 | 26.5% | |
| 2 | 1760 | 26.4% | |
| 3 | 1217 | 18.2% | |
| 4 | 864 | 12.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 9 | 40 | < 0.1% | |
| 8 | 89 | < 0.1% | |
| 7 | 120 | < 0.1% | |
| 6 | 279 | < 0.1% | |
| 5 | 510 | 7.6% |
person_capacity
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.2375 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| Median | 4 |
| Q3 | 6 |
| 95-th percentile | 10 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 2.9733 |
|---|---|
| Coef of variation | 0.56769 |
| Kurtosis | 2.1097 |
| Mean | 5.2375 |
| MAD | 2.2816 |
| Skewness | 1.3071 |
| Sum | 34950 |
| Variance | 8.8406 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 4 | 1558 | 23.3% | |
| 2 | 1425 | 21.4% | |
| 6 | 1234 | 18.5% | |
| 8 | 675 | 10.1% | |
| 5 | 486 | 7.3% | |
| 3 | 376 | 5.6% | |
| 10 | 275 | < 0.1% | |
| 7 | 206 | < 0.1% | |
| 12 | 122 | < 0.1% | |
| 16 | 112 | < 0.1% | |
| Other values (6) | 204 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 27 | < 0.1% | |
| 2 | 1425 | 21.4% | |
| 3 | 376 | 5.6% | |
| 4 | 1558 | 23.3% | |
| 5 | 486 | 7.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 112 | < 0.1% | |
| 15 | 26 | < 0.1% | |
| 14 | 36 | < 0.1% | |
| 13 | 16 | < 0.1% | |
| 12 | 122 | < 0.1% |
picture_count
Numeric
| Distinct count | 119 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.542 |
|---|---|
| Minimum | 1 |
| Maximum | 182 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 13 |
| Median | 21 |
| Q3 | 31 |
| 95-th percentile | 55 |
| Maximum | 182 |
| Range | 181 |
| Interquartile range | 18 |
Descriptive statistics
| Standard deviation | 16.228 |
|---|---|
| Coef of variation | 0.66124 |
| Kurtosis | 7.4591 |
| Mean | 24.542 |
| MAD | 11.889 |
| Skewness | 1.9315 |
| Sum | 1.6377e+05 |
| Variance | 263.35 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 17 | 255 | < 0.1% | |
| 13 | 243 | < 0.1% | |
| 9 | 222 | < 0.1% | |
| 18 | 221 | < 0.1% | |
| 20 | 220 | < 0.1% | |
| 15 | 217 | < 0.1% | |
| 12 | 212 | < 0.1% | |
| 23 | 212 | < 0.1% | |
| 19 | 207 | < 0.1% | |
| 16 | 203 | < 0.1% | |
| Other values (109) | 4461 | 66.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 33 | < 0.1% | |
| 2 | 22 | < 0.1% | |
| 3 | 35 | < 0.1% | |
| 4 | 63 | < 0.1% | |
| 5 | 89 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 182 | 1 | < 0.1% | |
| 167 | 1 | < 0.1% | |
| 156 | 1 | < 0.1% | |
| 155 | 1 | < 0.1% | |
| 148 | 1 | < 0.1% |
price
Highly correlated
This variable is highly correlated with amt_w_service and should be ignored for analysis
| Correlation | 1 |
|---|
rate_type
Constant
This variable is constant and should be ignored for analysis
| Constant value | nightly |
|---|
response_rate
Numeric
| Distinct count | 43 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 76.997 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros (%) | 19.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 80 |
| Median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range | 20 |
Descriptive statistics
| Standard deviation | 39.621 |
|---|---|
| Coef of variation | 0.51458 |
| Kurtosis | -0.068131 |
| Mean | 76.997 |
| MAD | 32.489 |
| Skewness | -1.3458 |
| Sum | 5.138e+05 |
| Variance | 1569.8 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 100 | 4178 | 62.6% | |
| 0 | 1328 | 19.9% | |
| 90 | 167 | < 0.1% | |
| 98 | 133 | < 0.1% | |
| 50 | 90 | < 0.1% | |
| 80 | 79 | < 0.1% | |
| 97 | 66 | < 0.1% | |
| 93 | 64 | < 0.1% | |
| 94 | 55 | < 0.1% | |
| 74 | 51 | < 0.1% | |
| Other values (33) | 462 | 6.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1328 | 19.9% | |
| 10 | 1 | < 0.1% | |
| 20 | 4 | < 0.1% | |
| 25 | 7 | < 0.1% | |
| 29 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 4178 | 62.6% | |
| 99 | 27 | < 0.1% | |
| 98 | 133 | < 0.1% | |
| 97 | 66 | < 0.1% | |
| 96 | 22 | < 0.1% |
response_time
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 18.2% |
| Missing (n) | 1217 |
| within an hour | |
|---|---|
| within a few hours | 692 |
| within a day | 540 |
| (Missing) |
| Value | Count | Frequency (%) | |
| within an hour | 4063 | 60.9% | |
| within a few hours | 692 | 10.4% | |
| within a day | 540 | 8.1% | |
| a few days or more | 161 | < 0.1% | |
| (Missing) | 1217 | 18.2% |
| Max length | 18 |
|---|---|
| Mean length | 12.343 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
reviews_count
Numeric
| Distinct count | 231 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 20.124 |
|---|---|
| Minimum | 0 |
| Maximum | 581 |
| Zeros (%) | 31.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 4 |
| Q3 | 22 |
| 95-th percentile | 96 |
| Maximum | 581 |
| Range | 581 |
| Interquartile range | 22 |
Descriptive statistics
| Standard deviation | 40.221 |
|---|---|
| Coef of variation | 1.9987 |
| Kurtosis | 31.471 |
| Mean | 20.124 |
| MAD | 24.278 |
| Skewness | 4.4189 |
| Sum | 1.3428e+05 |
| Variance | 1617.8 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 2089 | 31.3% | |
| 1 | 602 | 9.0% | |
| 2 | 351 | 5.3% | |
| 3 | 291 | < 0.1% | |
| 4 | 197 | < 0.1% | |
| 5 | 162 | < 0.1% | |
| 6 | 159 | < 0.1% | |
| 7 | 113 | < 0.1% | |
| 8 | 102 | < 0.1% | |
| 9 | 98 | < 0.1% | |
| Other values (221) | 2509 | 37.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2089 | 31.3% | |
| 1 | 602 | 9.0% | |
| 2 | 351 | 5.3% | |
| 3 | 291 | < 0.1% | |
| 4 | 197 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 581 | 1 | < 0.1% | |
| 537 | 1 | < 0.1% | |
| 482 | 1 | < 0.1% | |
| 481 | 1 | < 0.1% | |
| 475 | 1 | < 0.1% |
room_type_category
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| entire_home | |
|---|---|
| private_room | |
| shared_room | 19 |
| Value | Count | Frequency (%) | |
| entire_home | 5013 | 75.1% | |
| private_room | 1641 | 24.6% | |
| shared_room | 19 | < 0.1% |
| Max length | 12 |
|---|---|
| Mean length | 11.246 |
| Min length | 11 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
star_rating
Highly correlated
This variable is highly correlated with guest_satisfication and should be ignored for analysis
| Correlation | 0.91733 |
|---|
url
URL
| Distinct count | 6673 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Value | Count | Frequency (%) | |
| https://www.airbnb.com/rooms/18758185 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/35686080 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/33655772 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/32168685 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/31615807 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/34463515 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/21096786 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/23649627 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/12191587 | 1 | < 0.1% | |
| https://www.airbnb.com/rooms/11300329 | 1 | < 0.1% | |
| Other values (6663) | 6663 | > 99.9% |
| Value | Count | Frequency (%) | |
| https | 6673 | 100.0% |
| Value | Count | Frequency (%) | |
| www.airbnb.com | 6673 | 100.0% |
| Value | Count | Frequency (%) | |
| /rooms/19500867 | 1 | < 0.1% | |
| /rooms/32957158 | 1 | < 0.1% | |
| /rooms/33334004 | 1 | < 0.1% | |
| /rooms/21891360 | 1 | < 0.1% | |
| /rooms/14930294 | 1 | < 0.1% | |
| /rooms/32839147 | 1 | < 0.1% | |
| /rooms/23433141 | 1 | < 0.1% | |
| /rooms/35804675 | 1 | < 0.1% | |
| /rooms/34084587 | 1 | < 0.1% | |
| /rooms/27306201 | 1 | < 0.1% | |
| Other values (6663) | 6663 | > 99.9% |
| Value | Count | Frequency (%) | |
| 6673 | 100.0% |
| Value | Count | Frequency (%) | |
| 6673 | 100.0% |
value
Highly correlated
This variable is highly correlated with location and should be ignored for analysis
| Correlation | 0.98687 |
|---|
weekly_price_factor
Numeric
| Distinct count | 41 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.95204 |
|---|---|
| Minimum | 0.43 |
| Maximum | 1 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.43 |
|---|---|
| 5-th percentile | 0.81 |
| Q1 | 0.9 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 0.57 |
| Interquartile range | 0.1 |
Descriptive statistics
| Standard deviation | 0.063889 |
|---|---|
| Coef of variation | 0.067107 |
| Kurtosis | 2.2412 |
| Mean | 0.95204 |
| MAD | 0.052484 |
| Skewness | -1.3899 |
| Sum | 6352.9 |
| Variance | 0.0040817 |
| Memory size | 52.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 3596 | 53.9% | |
| 0.9 | 1153 | 17.3% | |
| 0.95 | 764 | 11.4% | |
| 0.85 | 329 | < 0.1% | |
| 0.79 | 146 | < 0.1% | |
| 0.8 | 111 | < 0.1% | |
| 0.92 | 74 | < 0.1% | |
| 0.97 | 67 | < 0.1% | |
| 0.88 | 57 | < 0.1% | |
| 0.93 | 52 | < 0.1% | |
| Other values (31) | 324 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.43 | 1 | < 0.1% | |
| 0.5 | 1 | < 0.1% | |
| 0.6 | 1 | < 0.1% | |
| 0.62 | 2 | < 0.1% | |
| 0.63 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 3596 | 53.9% | |
| 0.99964 | 1 | < 0.1% | |
| 0.99 | 16 | < 0.1% | |
| 0.98 | 23 | < 0.1% | |
| 0.97 | 67 | < 0.1% |
Matrix
Count
Heatmap
Dendrogram
First rows
| accuracy | amt_w_service | avg_rating | bathrooms | bedrooms | can_instant_book | checkin | cleanliness | communication | currency | guest_satisfication | host_id | host_reviews | is_business_travel_ready | is_fully_refundable | is_new_listing | is_superhost | lat | listing_name | lng | localized_city | localized_neighborhood | location | monthly_price_factor | num_beds | person_capacity | picture_count | price | rate_type | response_rate | response_time | reviews_count | room_type_category | star_rating | url | value | weekly_price_factor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 10 | 22 | 4.74 | 1.0 | 1.0 | True | 10 | 9 | 10 | CAD | 95 | 43548195 | 311 | False | True | False | True | 21.135660 | C1 ✪ Renovado Mini Room A/C laguna y mar | -86.767410 | Cancún | NaN | 10 | 0.88 | 1 | 2 | 19 | 22 | nightly | 100 | within an hour | 50 | private_room | 5.0 | https://www.airbnb.com/rooms/20776319 | 10 | 0.88 |
| 1 | 10 | 28 | 4.93 | 1.0 | 1.0 | False | 10 | 10 | 10 | CAD | 99 | 94835591 | 147 | False | True | False | True | 21.145710 | Habitación privada en la mejor ubicación, albe... | -86.841900 | Cancún | NaN | 10 | 0.85 | 1 | 2 | 22 | 28 | nightly | 100 | within a few hours | 108 | private_room | 5.0 | https://www.airbnb.com/rooms/16492050 | 10 | 0.90 |
| 2 | 10 | 30 | 4.72 | 1.5 | 1.0 | True | 10 | 9 | 10 | CAD | 94 | 85187388 | 1376 | False | True | False | False | 21.131190 | BEST LOCATION IN HOTEL ZONE, SECURE AND COZY! | -86.763940 | Cancún | NaN | 9 | 1.00 | 1 | 2 | 14 | 30 | nightly | 100 | within an hour | 243 | private_room | 4.5 | https://www.airbnb.com/rooms/14266451 | 9 | 1.00 |
| 3 | 10 | 24 | 4.75 | 1.0 | 2.0 | True | 10 | 9 | 10 | CAD | 95 | 91309199 | 179 | False | True | False | True | 21.157370 | Aparment for all the family in Cancun´s downtown | -86.839750 | Cancún | NaN | 10 | 0.79 | 2 | 5 | 27 | 24 | nightly | 97 | within an hour | 177 | entire_home | 5.0 | https://www.airbnb.com/rooms/17625889 | 10 | 0.93 |
| 4 | 10 | 21 | 4.65 | 1.0 | 1.0 | True | 10 | 9 | 10 | CAD | 93 | 128623591 | 631 | False | True | False | False | 21.153270 | PRIVATE ROOM. A / C. BREAKFAST. PRIVATE ACCESS | -86.855480 | Cancún | NaN | 9 | 0.80 | 2 | 3 | 18 | 21 | nightly | 100 | within an hour | 194 | entire_home | 4.5 | https://www.airbnb.com/rooms/18543147 | 9 | 0.95 |
| 5 | 10 | 29 | 4.84 | 1.0 | 1.0 | True | 10 | 10 | 10 | CAD | 97 | 117373947 | 521 | False | True | False | True | 21.165480 | Mi CaSiTa DoS | -86.831240 | Cancún | NaN | 10 | 1.00 | 1 | 2 | 18 | 29 | nightly | 100 | within an hour | 196 | entire_home | 5.0 | https://www.airbnb.com/rooms/21853372 | 10 | 1.00 |
| 6 | 10 | 29 | 4.91 | 1.0 | 1.0 | False | 10 | 10 | 10 | CAD | 98 | 26074835 | 1735 | False | True | False | True | 21.154510 | Charming private room away from tourist area ☆... | -86.822830 | Cancún | NaN | 10 | 1.00 | 1 | 2 | 25 | 29 | nightly | 100 | within an hour | 324 | private_room | 5.0 | https://www.airbnb.com/rooms/8798839 | 10 | 0.90 |
| 7 | 10 | 28 | 4.95 | 1.0 | 1.0 | True | 10 | 10 | 10 | CAD | 99 | 155168508 | 64 | False | True | False | True | 21.184435 | Tropical Experience Cancun-Cozy Room Cancun City | -86.830498 | Cancún | NaN | 9 | 1.00 | 1 | 3 | 22 | 28 | nightly | 100 | within an hour | 63 | private_room | 5.0 | https://www.airbnb.com/rooms/21413573 | 10 | 1.00 |
| 8 | 10 | 24 | 4.68 | 1.0 | 1.0 | True | 9 | 10 | 10 | CAD | 94 | 10831142 | 176 | False | True | False | False | 21.148240 | Casa Lava | -86.827240 | Cancún | NaN | 9 | 0.90 | 1 | 2 | 13 | 24 | nightly | 95 | within an hour | 171 | private_room | 4.5 | https://www.airbnb.com/rooms/20122417 | 10 | 0.95 |
| 9 | 10 | 25 | 4.70 | 1.0 | 1.0 | True | 10 | 9 | 10 | CAD | 94 | 126301804 | 213 | False | True | False | False | 21.157590 | RECÁMARA ANONA CANCÚN a 7 min de ZONA HOTELERA | -86.832950 | Cancún | NaN | 10 | 1.00 | 1 | 2 | 24 | 25 | nightly | 97 | within an hour | 118 | entire_home | 4.5 | https://www.airbnb.com/rooms/23809351 | 10 | 1.00 |
Last rows
| accuracy | amt_w_service | avg_rating | bathrooms | bedrooms | can_instant_book | checkin | cleanliness | communication | currency | guest_satisfication | host_id | host_reviews | is_business_travel_ready | is_fully_refundable | is_new_listing | is_superhost | lat | listing_name | lng | localized_city | localized_neighborhood | location | monthly_price_factor | num_beds | person_capacity | picture_count | price | rate_type | response_rate | response_time | reviews_count | room_type_category | star_rating | url | value | weekly_price_factor | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6663 | 0 | 655 | 0.00 | 2.0 | 2.0 | False | 0 | 0 | 0 | CAD | 0 | 240673465 | 0 | False | False | False | False | 20.764730 | Suite con Dos Recámaras de Mayan Palace | -86.954420 | Riviera Maya | NaN | 0 | 1.0 | 4 | 8 | 15 | 655 | nightly | 100 | within a day | 0 | entire_home | NaN | https://www.airbnb.com/rooms/32283555 | 0 | 1.00 |
| 6664 | 0 | 655 | 0.00 | 1.0 | 1.0 | True | 0 | 0 | 0 | CAD | 0 | 176343704 | 0 | False | False | False | False | 20.729070 | Grand Bliss in Vidanta Resort, Mayan Riviera | -87.004350 | Playa del Carmen | NaN | 0 | 1.0 | 1 | 6 | 5 | 655 | nightly | 100 | within a few hours | 0 | entire_home | NaN | https://www.airbnb.com/rooms/28583334 | 0 | 1.00 |
| 6665 | 10 | 655 | 5.00 | 3.0 | 3.0 | False | 10 | 10 | 10 | CAD | 100 | 16265252 | 398 | False | False | False | True | 20.614038 | Beautiful Villa with amazing private pool. | -87.081673 | Playa del Carmen | NaN | 10 | 0.8 | 5 | 8 | 40 | 655 | nightly | 100 | within an hour | 8 | entire_home | 5.0 | https://www.airbnb.com/rooms/27092203 | 10 | 0.90 |
| 6666 | 10 | 655 | 4.83 | 3.0 | 3.0 | True | 10 | 10 | 10 | CAD | 97 | 78349342 | 38 | False | False | False | False | 20.616230 | Casa Moskito, Oceanfront, Beautiful New Villa | -87.078540 | Playa del Carmen | NaN | 10 | 0.9 | 4 | 8 | 38 | 655 | nightly | 100 | within an hour | 30 | entire_home | 5.0 | https://www.airbnb.com/rooms/13590317 | 10 | 0.95 |
| 6667 | 10 | 655 | 5.00 | 2.0 | 2.0 | False | 10 | 10 | 10 | CAD | 100 | 96900082 | 2 | False | False | False | False | 20.633180 | Luxury Caribbean Condo | -87.067840 | Playa del Carmen | NaN | 10 | 1.0 | 3 | 6 | 16 | 655 | nightly | 0 | NaN | 1 | entire_home | NaN | https://www.airbnb.com/rooms/15240869 | 10 | 0.90 |
| 6668 | 9 | 721 | 4.60 | 5.5 | 4.0 | True | 10 | 9 | 9 | CAD | 92 | 155836547 | 11 | False | False | False | False | 21.116180 | MARALAGO HOUSE | -86.766440 | Cancún | NaN | 9 | 1.0 | 4 | 8 | 18 | 721 | nightly | 0 | NaN | 5 | entire_home | 4.5 | https://www.airbnb.com/rooms/21579184 | 9 | 1.00 |
| 6669 | 0 | 744 | 0.00 | 3.5 | 3.0 | True | 0 | 0 | 0 | CAD | 0 | 195848484 | 0 | False | False | False | False | 20.632350 | *NO GUEST SERVICE FEE* Magic - 3 Bedrooms Pent... | -87.065840 | Playa del Carmen | NaN | 0 | 1.0 | 5 | 10 | 50 | 744 | nightly | 100 | within an hour | 0 | entire_home | NaN | https://www.airbnb.com/rooms/26170853 | 0 | 1.00 |
| 6670 | 10 | 781 | 5.00 | 3.0 | 3.0 | True | 10 | 10 | 10 | CAD | 100 | 193426116 | 10 | False | False | False | False | 21.518520 | Casa Mariposa (Tulip) In Holbox | -87.389390 | Isla Holbox | NaN | 10 | 1.0 | 5 | 8 | 18 | 781 | nightly | 100 | within an hour | 2 | entire_home | NaN | https://www.airbnb.com/rooms/31122862 | 10 | 1.00 |
| 6671 | 9 | 853 | 5.00 | 4.5 | 4.0 | False | 9 | 10 | 9 | CAD | 100 | 15492891 | 296 | False | False | False | False | 20.927374 | Paradise Villa | -86.842155 | Puerto Morelos | NaN | 9 | 0.9 | 7 | 10 | 36 | 853 | nightly | 100 | within an hour | 4 | entire_home | 5.0 | https://www.airbnb.com/rooms/3431143 | 9 | 0.95 |
| 6672 | 0 | 994 | 0.00 | 2.0 | 3.0 | False | 0 | 0 | 0 | CAD | 0 | 1541602 | 47 | False | False | False | True | 20.626860 | 3 Bedroom/2 Bath Luxury Oceanside Penthouse | -87.071060 | Playa del Carmen | NaN | 0 | 1.0 | 4 | 6 | 18 | 994 | nightly | 100 | within a day | 0 | entire_home | NaN | https://www.airbnb.com/rooms/13694877 | 0 | 0.90 |